db.getCollection('TemplateCriteria').update({}, {$set: {"HasFullRangeChart": false}}, {upsert: false, multi: true})

db.getCollection('TemplateCriteria').update({"CriteriaType" : 6, "CriteriaEntityField" : "Total ESG Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 6, "CriteriaEntityField" : "Comparative Group Average"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 6, "CriteriaEntityField" : "Environment Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 6, "CriteriaEntityField" : "Social Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 6, "CriteriaEntityField" : "Governance Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 6, "CriteriaEntityField" : "Preparedness Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 6, "CriteriaEntityField" : "Disclosure Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 6, "CriteriaEntityField" : "Quantitative Performance Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 6, "CriteriaEntityField" : "Qualitative Performance Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 6, "CriteriaEntityField" : "Comparative Group Average Environment"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 6, "CriteriaEntityField" : "Comparative Group Average Governance"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 6, "CriteriaEntityField" : "Comparative Group Average Social"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})

db.getCollection('TemplateCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Overall Corporate Governance Score-Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Board/Management Quality & Integrity-Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Board/Management Quality & Integrity-Weight"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Board/Management Quality & Integrity-Weighted Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Board Structure-Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Board Structure-Weight"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Board Structure-Weighted Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Ownership & Shareholder Rights-Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Ownership & Shareholder Rights-Weight"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Ownership & Shareholder Rights-Weighted Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Remuneration-Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Remuneration-Weight"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Remuneration-Weighted Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Audit & Financial Reporting-Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Audit & Financial Reporting-Weight"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Audit & Financial Reporting-Weighted Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Stakeholder Governance-Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Stakeholder Governance-Weight"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})
db.getCollection('TemplateCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Stakeholder Governance-Weighted Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: false})



db.getCollection('FilterCriteria').update({}, {$set: {"HasFullRangeChart": false}}, {upsert: false, multi: true})

db.getCollection('FilterCriteria').update({"CriteriaType" : 6, "CriteriaEntityField" : "Total ESG Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 6, "CriteriaEntityField" : "Comparative Group Average"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 6, "CriteriaEntityField" : "Environment Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 6, "CriteriaEntityField" : "Social Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 6, "CriteriaEntityField" : "Governance Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 6, "CriteriaEntityField" : "Preparedness Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 6, "CriteriaEntityField" : "Disclosure Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 6, "CriteriaEntityField" : "Quantitative Performance Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 6, "CriteriaEntityField" : "Qualitative Performance Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 6, "CriteriaEntityField" : "Comparative Group Average Environment"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 6, "CriteriaEntityField" : "Comparative Group Average Governance"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 6, "CriteriaEntityField" : "Comparative Group Average Social"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})

db.getCollection('FilterCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Overall Corporate Governance Score-Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Board/Management Quality & Integrity-Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Board/Management Quality & Integrity-Weight"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Board/Management Quality & Integrity-Weighted Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Board Structure-Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Board Structure-Weight"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Board Structure-Weighted Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Ownership & Shareholder Rights-Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Ownership & Shareholder Rights-Weight"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Ownership & Shareholder Rights-Weighted Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Remuneration-Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Remuneration-Weight"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Remuneration-Weighted Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Audit & Financial Reporting-Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Audit & Financial Reporting-Weight"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Audit & Financial Reporting-Weighted Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Stakeholder Governance-Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Stakeholder Governance-Weight"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})
db.getCollection('FilterCriteria').update({"CriteriaType" : 16, "CriteriaEntityField" : "Stakeholder Governance-Weighted Score"}, {$set: {"HasFullRangeChart": true}}, {upsert: false, multi: true})

